package cn.xhjava.crm.workbench.mapper;

import cn.xhjava.crm.workbench.domain.Customer;
import cn.xhjava.crm.workbench.domain.FunnelVO;

import java.util.List;
import java.util.Map;

public interface CustomerMapper {
    int deleteByPrimaryKey(String id) throws Exception;

    int insert(Customer record) throws Exception;

    int insertSelective(Customer record) throws Exception;

    Customer selectByPrimaryKey(String id) throws Exception;

    int updateByPrimaryKeySelective(Customer record) throws Exception;

    int updateByPrimaryKey(Customer record) throws Exception;

    Customer selectCustomerByName(String customerName) throws Exception;

    List<Customer> queryCustomerByConditionForPage(Map<String, Object> map) throws Exception;

    int queryCountOfCustomerByCondition(Map<String, Object> map) throws Exception;

    Customer selectDetailById(String id) throws Exception;

    List<String> queryCustomerNamesLikeName(String customerName) throws Exception;

    List<FunnelVO> queryCustomerCountGroupByCreateTime() throws Exception;
}